package org.eoti.rei.ndfcmd;

/**
 * The MIT License
 * <p/>
 * Copyright (c) 2009 Malachi de AElfweald (malachid@gmail.com)
 * <p/>
 * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
 * documentation files (the "Software"), to deal in the Software without restriction, including without limitation the
 * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to the following conditions:
 * <p/>
 * The above copyright notice and this permission notice shall be included in all copies or substantial portions of the
 * Software.
 * <p/>
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
 * WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
 * COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR
 * OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 */
import org.eoti.io.xls.XLSColumn;
import org.eoti.io.xls.XLSReader;

import java.util.*;

public class SQFTCmd
	extends LtGtCmd
{
	public String[] commands(){
		return new String[]{"sqft"};
	}

	public void lessThan(int amount)
	{
		XLSReader reader = browser.getReader();
		XLSColumn column = reader.getColumn("Gross Area");
		ArrayList<Integer> toRemove = new ArrayList<Integer>();
		for(int row : reader.rows())
		{
			if( ((Double)(column.getValue(row))).intValue() > amount)
				toRemove.add(row);
		}

		reader.removeAll(toRemove);
		browser.report();
	}

	public void moreThan(int amount)
	{
		XLSReader reader = browser.getReader();
		XLSColumn column = reader.getColumn("Gross Area");
		ArrayList<Integer> toRemove = new ArrayList<Integer>();
		for(int row : reader.rows())
		{
			if( ((Double)(column.getValue(row))).intValue() < amount)
				toRemove.add(row);
		}

		reader.removeAll(toRemove);
		browser.report();
	}

	public void displayHelp()
	{
		format("sqft < 1500: only include houses with sqft under 1500\n");
		format("sqft > 1200: only include houses with sqft above 1200\n");
	}
}
